|
|
|
|
|
|
|
DBAdoConnection, DBRdoConnection, and DBDaoConnection each have the following members: |
|
|
|
|
|
|
|
|
Public Function beginDBTrans() As Variant
Public Sub closeDBConnection(Optional argConnection)
Public Sub commitDBTrans()
Public Property Get DefaultDriverName() As String
Public Property Get DefaultServerName() As String
Public Function executeSQL(argSQL As String) As Variant
Public Function executeSQL(argSQL As String) As Variant
Public Sub openConnection(argConnStr As String)
Public Property Get pDBConnection() As Database
Public Function rollbackDBTrans() As Variant
Public Function setColumn(argCol As Object) As Variant |
|
|
|
|
|
|
|
|
The methods beginDBTrans, commitDBTrans, and rollbackDBTrans handle any operations that are grouped as transactions. The methods openConnection and closeDBConnection open and close, respectively, the connection to the database. As mentioned for IDBSubsystem, DefaultDriverName, and DefaultServerName are used to specify the default driver name of the ODBC driver and the default server name of the database server. ExecuteSQL directly executes a SQL statement against a specified connection referenced by pDBConnection. Finally, setColumn sets a reference to a column specified by the argCol object argument. |
|
|
|
|
|
|
|
|
DBAdoResultset, DBRdoResultset, and DBDaoResultset have the following members: |
|
|
|
|
|
|
|
|
Public Sub addNewRecord()
Public Sub CancelTrans()
Public pChangedByCode As Boolean
Public pBookMark As Variant
Public pEditFlag As Boolean
Public pAddNewFlag As Boolean
Public pDataChanged As Boolean
Public Property Get DBColumn() As Object
Public Sub getFirstRec()
Public Sub getLastRec()
Public Sub getNextRec()
Public Sub getPreviousRec()
Public Function getRecordCount() As Long
Public Sub openDBResultset(argSQL As String, _ Optional argDBConnection As ADODB.Connection)
Public Property Get pBOF() As Boolean
Public Property Get pCurrentSQL() As String
Public Property Get pEOF() As Boolean
Public Sub prepareForChange()
Public Property Get pResultset() As Object
Public Property Get pSQLTimeout() As Integer
Public Property Get RSFields() As Object
Public Sub startEditMode() |
|
|
|
|
|